package com.fz.jdbc;

import com.hzw.utils.JdbcUtil;

public class AppTest {
    public static void main(String[] args) throws  Exception{
        int i=0;
        i= JdbcUtils.update("insert into `user`(username,`password`)values('nb',MD5('123'))");
        if (i>0){
            System.out.println("插入成功");
        }
        i= JdbcUtils.update("update `user` set `password`=MD5('111') where id=4");
        if (i>0){
            System.out.println("修改成功");
        }
        i= JdbcUtils.update("delete from `user` where id=7");
        if (i>0){
            System.out.println("删除成功");
        }
        JdbcUtils.select("select id,username from `user` order by id");


    }
}
